<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateNwYbzYjjxybzTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('nw_ybz_yjjxybz', function (Blueprint $table) {
            $table->id();
            $table->string('cabinet_position')->nullable()->comment('柜位');
            $table->integer('start_height_u')->nullable()->comment('设备起始高度(U)');
            $table->integer('end_height_u')->nullable()->comment('设备终止高度(U)');
            $table->timestamp('fault_time')->nullable()->comment('故障时间');
            $table->string('device_sn')->nullable()->comment('设备SN');
            $table->string('device_bmc')->nullable()->comment('设备BMC');
            $table->string('host_name')->nullable()->comment('主机名称');
            $table->string('i6000_name')->nullable()->comment('对应I6000名称');
            $table->string('replacement_part')->nullable()->comment('更换备件');
            $table->string('faulty_part_slot')->nullable()->comment('故障备件槽位');
            $table->string('pre_replacement_sn')->nullable()->comment('更换前序列号');
            $table->string('post_replacement_sn')->nullable()->comment('更换后序列号');
            $table->string('replacement_status')->nullable()->comment('更换状态');
            $table->string('inspection_time')->nullable()->comment('检修时间');
            $table->string('spare_parts_arrival')->nullable()->comment('备件到货情况');
            $table->string('inspection_completed_at')->nullable()->comment('检修完成时间');
            $table->text('remarks')->nullable()->comment('备注');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('nw_ybz_yjjxybz');
    }
}
